<?php
namespace Jykj\Mass\Domain\Repository;

/***************************************************************
 *
 *  Copyright notice
 *
 *  (c) 2017 WHB <wanghongbin@ngoos.org>, 极益科技
 *
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

/**
 * The repository for Sms
 */
class SmsRepository extends \TYPO3\CMS\Extbase\Persistence\Repository
{
	/**
	 * [findAlls description]
	 * @param  [type] $svalid  [description]
	 * @param  [type] $evalid  [description]
	 * @param  [type] $keyword [description]
	 * @return [type]          [description]
	 */
    public function findAlls($svalid,$evalid,$keyword)
    {
    	$query = $this->createQuery();
		$wherearr=array();
		if($svalid!="" || $svalid!=null){
			$wherearr[] =$query->greaterThanOrEqual('crdate',strtotime($svalid));
		}
		if($evalid!="" || $evalid!=null){
			$wherearr[] =$query->lessThanOrEqual('crdate',strtotime($evalid));
		}
	
		if($keyword!="" || $keyword!=null){
			$wherearr[] =$query->like('sender','%'.$keyword.'%');
			$wherearr[] =$query->like('modelNum','%'.$keyword.'%');
		}
		
		if (!empty($wherearr)) {
			$query->matching($query->logicalAnd($wherearr));
		}
		$query->setOrderings(array(
				'crdate' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_DESCENDING,
				'sendStatus' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING,
		));
	
		$result = $query->execute();
		return $result;
    }
    
}